Tabela RecordManipulationLog

Definicja tabeli RecordManipulationLog

Name

RecordManipulationLog

Code

RecordManipulationLog

Comment

Log z akcjami wykonanymi przez ekran do modyfikowania epizodow


Lista kolumn tabeli RecordManipulationLog

Name

Code

RecordManipulationLogID

RecordManipulationLogID

TableName

TableName

PKeyID

PKeyID

ActionTypeID

ActionTypeID

ClientIP

ClientIP


Kolumna RecordManipulationLogID tabeli RecordManipulationLog

Definicja kolumny RecordManipulationLogID tabeli RecordManipulationLog

Name

RecordManipulationLogID

Code

RecordManipulationLogID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz glówny, z sekwencja


Kolumna TableName tabeli RecordManipulationLog

Definicja kolumny TableName tabeli RecordManipulationLog

Name

TableName

Code

TableName

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

Tabela w której dotyczy rekord


Kolumna PKeyID tabeli RecordManipulationLog

Definicja kolumny PKeyID tabeli RecordManipulationLog

Name

PKeyID

Code

PKeyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz glówny z tabeli której dotyczy rekord


Kolumna ActionTypeID tabeli RecordManipulationLog

Definicja kolumny ActionTypeID tabeli RecordManipulationLog

Name

ActionTypeID

Code

ActionTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Id akcji


Kolumna ClientIP tabeli RecordManipulationLog

Definicja kolumny ClientIP tabeli RecordManipulationLog

Name

ClientIP

Code

ClientIP

Data Type

VARCHAR2(15)

Mandatory

No

Comment

IP uzytkownika


Lista kluczy tabeli RecordManipulationLog

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli RecordManipulationLog

Definicja klucza Identifier_1 tabeli RecordManipulationLog

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment